◀ Prev · Parts · Full · Next ▶

• Application time tables are queried using regular query syntax or using new temporal predicates for time periods including CONTAINS, OVERLAPS, EQUALS, PRECEDES, SUCCEEDS, IMMEDIATELY PRECEDES and IMMEDIATELY SUCCEEDS (which are modified versions of Allen’s interval relations)

• Definition of system-versioned tables (elsewhere called transaction time tables), using the PERIOD FOR SYSTEM_TIME annotation and WITH SYSTEM VERSIONING modifier. System time periods are maintained automatically. Constraints for system-versioned tables are not required to be temporal and are only enforced on current rows

• Syntax for time-sliced and sequenced queries on system time tables via the AS OF SYSTEM TIME and VERSIONS BETWEEN SYSTEM TIME ... AND ... clauses

• Application time and system versioning can be used together to provide bitemporal tables

SAP HANA 2.0 SP03 supports system-versioned tablescite-ref-4[4] using the standard select syntax FOR SYSTEM_TIME AS OF '<timestamp1>'cite-ref-5[5] SAP HANA 2.0 SP04 adds (partial) support for application-time versioning cite-ref-6[6]

◀ Prev · Parts · Full · Next ▶